package com.ice.body.business.dao;

import com.ice.body.business.model.VideoMonitorModel;
import com.ice.base.dao.BaseDao;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
/**
 * Created with GuoYanBin.
 * Description:业务接口-监控录像 mapper
 * Date: 2021-06-18
 * Time: 02:58
 */
@Mapper
public interface VideoMonitorDao extends BaseDao<VideoMonitorModel>{

    //删除大于7天的视频数据
    @Delete("delete FROM t_video_monitor WHERE createTime  < NOW() - INTERVAL 30 DAY")
    boolean delete7Videos();

}